<?php
$a = 857;
$x=date("Y");
$cx= $x.-10;
$jan = mysql_query("select count(*) as CANT from ticket where open_datetime like '%$cx%' and status='Open' order by ticket_id desc");
//var_dump(mysql_fetch_array($jan));
$fetch=  mysql_fetch_array($jan);
$jumlahrecord = $fetch['CANT'];
$b =$jumlahrecord;
echo "<graph caption=' Ticket Created' xAxisName='Month' yAxisName='Units' decimalPrecision='0' formatNumberScale='0'>";
echo "
	<set name='Jan' value='462' color='AFD8F8' />
<set name='Feb' value='$b' color='F6BD0F' />
<set name='Mar' value='671' color='8BBA00' />
<set name='Apr' value='494' color='FF8E46'/>
<set name='May' value='761' color='008E8E'/>
<set name='Jun' value='960' color='D64646'/>
<set name='Jul' value='629' color='8E468E'/>
<set name='Aug' value='622' color='588526'/>
<set name='Sep' value='376' color='B3AA00'/>
<set name='Oct' value='494' color='008ED6'/>
<set name='Nov' value='761' color='9D080D'/>
<set name='Dec' value='960' color='A186BE'/>


";

echo "</graph>";


?>